comparing two tables [closed]

Posted by sza on Programmers See other posts from Programmers or by sza
Published on 2011-01-11T19:00:35Z Indexed on 2011/01/11 19:59 UTC
Read the original article Hit count: 170

Filed under:

I have two identical table ie all the columns are identical and one of the datatype is Text, one is varchar(255) and the rest are int. Lets say the table name is 'AAAAA'. Table AAAAA was processed and backed up earlier this month. Both the tables were storing data and now the second table is only storing data. I need to find unmatching records from the second table (BBBBB) which is storing data right now and add those records to Table AAAAA.

Your help will be highly appreciated. I tried to use 'EXCEPT' but it does not support text datatype.

© Programmers or respective owner

Related posts about sql-server